package com.ruoyi.statistic.service;


import com.ruoyi.statistic.domain.StatisticStudentSchoolInfo;

import java.util.List;

public interface IStatisticStudentSchoolInfoService {
    /**
     * 新增学生院校信息
     *
     * @param studentSchoolInfo 学生院校信息
     * @return 结果
     */
    public int insertStatisticStudentSchoolInfo(StatisticStudentSchoolInfo studentSchoolInfo);


    /**
     * 删除所有数据
     */
    public void deleteAll();

    /**
     * 聚合学生学籍信息
     */
    public List<StatisticStudentSchoolInfo> aggregationStatisticStudentSchoolInfo();


    /**
     * 查询聚合学生年级
     *
     * @return
     */
    public List<StatisticStudentSchoolInfo> selectStatisticAggregationGrade();


    /**
     * 查询聚合学生系别
     *
     * @return
     */
    public List<StatisticStudentSchoolInfo> selectStatisticAggregationDepartment();


    /**
     * 查询聚合学生专业
     *
     * @return
     */
    public List<StatisticStudentSchoolInfo> selectStatisticAggregationMajor();
}
